package org.teststack.Api.Sl.MCcc;

import com.google.gson.internal.bind.util.ISO8601Utils;
import com.jayway.restassured.RestAssured;
import com.jayway.restassured.response.Response;
import org.apache.commons.codec.net.URLCodec;
import org.teststack.Api.RestClient;
import org.teststack.utils.ConMysql;


import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import java.net.URLEncoder;
import java.nio.charset.StandardCharsets;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;

import static org.teststack.Api.CookieManager.cookies;
import static org.teststack.utils.ConMysql.connection;


public class McccApi {
    public McccApi() throws SQLException, ClassNotFoundException {
    }//名称查重

    public static void main(String[] args) throws UnsupportedEncodingException, SQLException, ClassNotFoundException {
        mcccApi();
    }

    public static int mcccApi() throws UnsupportedEncodingException, SQLException, ClassNotFoundException {
        // 登录并更新cookies
        RestClient.loginAndUpdateCookies("liutao", "xQ5Vea/L3CMRNEwoBESSZGSVCnValY4kZcAYe3153B9/dXpazZRG8VLEuMhJdW1RhdZ/cqdUq/5FUdAxeKzdWOmZEj0sVlobwrqzRMgrIPsvyp03QTktVYRUAgloA924e5wLLSx8ECJ4WpUAB8zUa41GkyURFmyVtwxQ3EkLuabQ7V24L8EdzRfBHnFd8zRRd4RkncACXO88rrb4U7uR10ANvR0K4N2Kiai901pyztSuMfXP0fVRBW1lKj+kIONtFufTZoAL48++Q6VVr3r5B9tIC4kkwv0WzQxeOubbVKTNUi1JGnS2CEPPqjuXWJnUAO3u5PRxXmtH5+JN8yXygw==");
//        Map<String, String> formParams = new HashMap<>();
//        formParams.put("Content-Disposition: form-data; name=\"method\"", "enterMczzcc");
//        formParams.put("Content-Disposition: form-data; name=\"nameXzqh\"", "浙江");
//        formParams.put("Content-Disposition: form-data; name=\"nameZh\"", "非脚后跟");
//        formParams.put("Content-Disposition: form-data; name=\"nameHy\"", "建筑设计事务所");
//        formParams.put("Content-Disposition: form-data; name=\"nameZzxs\"", "有限公司");
//        formParams.put("Content-Disposition: form-data; name=\"nameQc\"", "浙江非脚后跟建筑设计事务所有限公司");
//        formParams.put("Content-Disposition: form-data; name=\"nameList\"", "浙江,发货的说法还是的,建筑设计事务所,有限公司,浙江非脚后跟建筑设计事务所有限公司;");
//        formParams.put("Content-Disposition: form-data; name=\"mcjbxx\"", "S_PROLOC_PROVINCE_:330000_,S_PROLOC_CITY_:330100_,S_PROLOC_DISTRICT_:330102_,S_PROLOC_LOCATION_:330102001_,S_PROLOC_:浙江省杭州市上城区清波街道_,S_QYZTLX_:01_,S_REGCAP_:_,S_HYDL_:M_,S_HYZL_:7400_,S_HYXL_:7484_,S_GMLX_:0_,S_TRADPINY_:SHIDAFUDANSHI_,S_ENTTRA_:非脚后跟_,S_QYLXDL_:11_,S_ENTTYPE_:1100_,S_ZCZJ_:_,S_RJCZE_:_,S_CZE_:_,S_SJQYENTNAME_:_,S_SJQYUNISCID_:_,S_COMMITLETTER_:_,S_MCZZXS_:有限公司,S_OPSCOPE_:工程设计活动_,S_JYFWBYHAND_:工程设计活动_,S_MCHYSIGN_:1_,S_ISQZSP_:undefined_,S_NAMEREGION_:浙江_,S_NAMEINDUSTRY_:建筑设计事务所_,S_BZSM_:tjcl_2_,S_ISPCOM_:2_,S_GRPNAME_:_,S_ITE_:0_,S_ITENAME_:_,S_ITEREGNO_:_,S_ZZSIGN_:hz");
//
//        formParams.put("Content-Disposition: form-data; name=\"S_PROLOC_PROVINCE\"", "330000");
//        formParams.put("Content-Disposition: form-data; name=\"S_PROLOC_CITY\"", "330100");
//        formParams.put("Content-Disposition: form-data; name=\"S_PROLOC_DISTRICT\"", "330102");
//        formParams.put("Content-Disposition: form-data; name=\"S_PROLOC_STREET\"", "330102001");
//        formParams.put("S_PROLOC", "浙江");
//        formParams.put("Content-Disposition: form-data; name=\"S_PROLOC\"", "浙江省杭州市上城区清波街道");
//        formParams.put("Content-Disposition: form-data; name=\"S_QYZTLX\"", "01");
//        formParams.put("Content-Disposition: form-data; name=\"S_MCZZXS\"", "11");
//        formParams.put("Content-Disposition: form-data; name=\"S_ENTTYPE\"", "1100");
//        formParams.put("Content-Disposition: form-data; name=\"S_ZZSIGN\"", "hz");
//        formParams.put("Content-Disposition: form-data; name=\"S_GMLX\"", "0");
//        formParams.put("Content-Disposition: form-data; name=\"S_TRADPINY\"", "FAHUODEYUEFAHUANSHIDE");
//        formParams.put("Content-Disposition: form-data; name=\"S_MCHYSIGN\"", "1");
//        formParams.put("Content-Disposition: form-data; name=\"S_HYDL\"", "M");
//        formParams.put("Content-Disposition: form-data; name=\"S_HYZL\"", "7400");
//        formParams.put("Content-Disposition: form-data; name=\"S_HYXL\"", "7484");
//        formParams.put("Content-Disposition: form-data; name=\"S_ISPCOM\"", "2");
//        formParams.put("Content-Disposition: form-data; name=\"S_ISQZSP\"", "undefined");
//        formParams.put("Content-Disposition: form-data; name=\"xzqh\"", "浙江");
//        formParams.put("Content-Disposition: form-data; name=\"mchy\"", "建筑设计事务所");
//        formParams.put("Content-Disposition: form-data; name=\"zzxs\"", "有限公司");
//        formParams.put("Content-Disposition: form-data; name=\"zyyw\"", "工程设计活动");
//        formParams.put("Content-Disposition: form-data; name=\"xzqhwz\"", "2");
//        formParams.put("Content-Disposition: form-data; name=\"sbms\"", "1");
//        formParams.put("Content-Disposition: form-data; name=\"ljmsign\"", "2");
//        formParams.put("Content-Disposition: form-data; name=\"znspsign\"", "0");
//        formParams.put("Content-Disposition: form-data; name=\"qylx\"", "qy");
//        formParams.put("Content-Disposition: form-data; name=\"S_NAME\"", "建筑");
//        formParams.put("Content-Disposition: form-data; name=\"zzxs-qylx-nwz\"", "nz");
//        formParams.put("Content-Disposition: form-data; name=\"10035\"; filename=\"8e03e80ae8b73cf434e0db0724b9c1ef.jpg\"\n" +
//                "Content-Type: image/jpeg", "<file>");


        String nameXzqh = "浙江";
        String nameZh = "非脚后跟";
        String nameHy = "建筑设计事务所";
        String nameZzxs = "有限责任公司";

        String nameQc = "浙江非脚后跟建筑设计事务所有限责任公司";
        String S_PROLOC = "浙江省杭州市上城区笕桥街道";
        String S_NAME = "建筑";
        String zyyw = "工程设计活动";
//        URLCodec urlCodec = new URLCodec();
//        String encodedParam = URLEncoder.encode(nameXzqh, "GBK");
//        String encodedParam1 = URLEncoder.encode(nameZh, "GBK");
//        String encodedParam2 = URLEncoder.encode(nameHy, "GBK");
//        String encodedParam3 = URLEncoder.encode(nameZzxs, "GBK");
//        String encodedParam4 = URLEncoder.encode(nameQc, "GBK");
//        String encodedParam5 = URLEncoder.encode(S_PROLOC, "GBK");
//        String encodedParam6 = URLEncoder.encode(S_NAME, "GBK");
//        String encodedParam7 = URLEncoder.encode(zyyw, "GBK");
        String formData = "/ywtSldj.do?method=doMczzcc_zj&csrftoken=&nameXzqh=" + nameXzqh + "&nameHhlx=&nameZh=" + nameZh + "&nameHy=" + nameHy + "&nameZzxs=" + nameZzxs + "&nameQc=" + nameQc + "&nameList=&mcjbxx=&sbid=&name_id=&pripid=&basemcclsm=&clidsm=&S_PROLOC_PROVINCE=330000&S_PROLOC_CITY=330100&S_PROLOC_DISTRICT=330102&S_PROLOC_STREET=330102016&S_PROLOC_LOCATION=&S_PROLOC=" + S_PROLOC + "&S_QYZTLX=01&S_REGCAP=&S_MCZZXS=" + nameZzxs + "&S_QYLXDL=11&S_ENTTYPE=1100&S_ZCZJ=&S_RJCZE=&S_CZE=&S_SJQYENTNAME=&S_SJQYUNISCID=&S_COMMITLETTER=&S_ZZSIGN=hz&S_GMLX=0&S_TRADPINY=ELABOBANDAO&S_MCHYSIGN=1&S_HYDL=M&S_HYZL=7400&S_HYXL=7484&S_ISPCOM=2&S_ISQZSP=undefined&xzqh=" + nameXzqh + "&mchy=" + nameHy + "&zzxs=" + nameZzxs + "&zyyw=" + zyyw + "&xzqhwz=0&sbms=1&ljmsign=&znspsign=0&thsign=&ghcomboid=&ghopscope=&gzqsign=&pri_pripid=&zrzysx=&qylx=qy&gtscmc=&zwzh=" + nameZh + "&S_NAME=" + S_NAME + "&zzxs-qylx-nwz=nz&zzxs-qylx=yx&wzmc=1&S_ITENAME=&S_ITEREGNO=&csrftoken=";
        String formParams = "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"method\"\n" +
                "\n" +
                "enterMczzcc\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"csrftoken\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameXzqh\"\n" +
                "\n" +
                "浙江\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameHhlx\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameZh\"\n" +
                "\n" +
                "非脚后跟\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameHy\"\n" +
                "\n" +
                "建筑设计事务所\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameZzxs\"\n" +
                "\n" +
                "有限公司\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameQc\"\n" +
                "\n" +
                "浙江非脚后跟建筑设计事务所有限公司\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"nameList\"\n" +
                "\n" +
                "浙江,非脚后跟,建筑设计事务所,有限公司,浙江非脚后跟建筑设计事务所有限公司;\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"mcjbxx\"\n" +
                "\n" +
                "S_PROLOC_PROVINCE_:330000_,S_PROLOC_CITY_:330100_,S_PROLOC_DISTRICT_:330102_,S_PROLOC_LOCATION_:330102001_,S_PROLOC_:浙江省杭州市上城区清波街道_,S_QYZTLX_:01_,S_REGCAP_:_,S_HYDL_:M_,S_HYZL_:7400_,S_HYXL_:7484_,S_GMLX_:0_,S_TRADPINY_:FEIJIAOHOUGEN_,S_ENTTRA_:非脚后跟_,S_QYLXDL_:11_,S_ENTTYPE_:1100_,S_ZCZJ_:_,S_RJCZE_:_,S_CZE_:_,S_SJQYENTNAME_:_,S_SJQYUNISCID_:_,S_COMMITLETTER_:_,S_MCZZXS_:有限公司_,S_OPSCOPE_:工程设计活动_,S_JYFWBYHAND_:工程设计活动_,S_MCHYSIGN_:1_,S_ISQZSP_:undefined_,S_NAMEREGION_:浙江_,S_NAMEINDUSTRY_:建筑设计事务所_,S_BZSM_:_,S_ISPCOM_:2_,S_GRPNAME_:_,S_ITE_:0_,S_ITENAME_:_,S_ITEREGNO_:_,S_ZZSIGN_:hz\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"sbid\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"name_id\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"pripid\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"basemcclsm\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"clidsm\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_PROLOC_PROVINCE\"\n" +
                "\n" +
                "330000\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_PROLOC_CITY\"\n" +
                "\n" +
                "330100\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_PROLOC_DISTRICT\"\n" +
                "\n" +
                "330102\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_PROLOC_STREET\"\n" +
                "\n" +
                "330102001\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_PROLOC_LOCATION\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_PROLOC\"\n" +
                "\n" +
                "浙江省杭州市上城区清波街道\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_QYZTLX\"\n" +
                "\n" +
                "01\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_REGCAP\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_MCZZXS\"\n" +
                "\n" +
                "有限公司\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_QYLXDL\"\n" +
                "\n" +
                "11\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ENTTYPE\"\n" +
                "\n" +
                "1100\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ZCZJ\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_RJCZE\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_CZE\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_SJQYENTNAME\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_SJQYUNISCID\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_COMMITLETTER\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ZZSIGN\"\n" +
                "\n" +
                "hz\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_GMLX\"\n" +
                "\n" +
                "0\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_TRADPINY\"\n" +
                "\n" +
                "FEIJIAOHOUGEN\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_MCHYSIGN\"\n" +
                "\n" +
                "1\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_HYDL\"\n" +
                "\n" +
                "M\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_HYZL\"\n" +
                "\n" +
                "7400\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_HYXL\"\n" +
                "\n" +
                "7484\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ISPCOM\"\n" +
                "\n" +
                "2\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ISQZSP\"\n" +
                "\n" +
                "undefined\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"xzqh\"\n" +
                "\n" +
                "浙江\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"mchy\"\n" +
                "\n" +
                "建筑设计事务所\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"zzxs\"\n" +
                "\n" +
                "有限公司\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"zyyw\"\n" +
                "\n" +
                "工程设计活动\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"xzqhwz\"\n" +
                "\n" +
                "0\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"sbms\"\n" +
                "\n" +
                "1\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"ljmsign\"\n" +
                "\n" +
                "2\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"znspsign\"\n" +
                "\n" +
                "0\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"thsign\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"ghcomboid\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"ghopscope\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"gzqsign\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"pri_pripid\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"zrzysx\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"qylx\"\n" +
                "\n" +
                "qy\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"gtscmc\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_NAME\"\n" +
                "\n" +
                "建筑\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"zzxs-qylx-nwz\"\n" +
                "\n" +
                "nz\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ITENAME\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"S_ITEREGNO\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"10035\"; filename=\"\"\n" +
                "Content-Type: application/octet-stream\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ\n" +
                "Content-Disposition: form-data; name=\"csrftoken\"\n" +
                "\n" +
                "\n" +
                "------WebKitFormBoundarym7n5DlL2zASbrxhQ--\n";
        System.out.println(formData);
        // 注意：这里我们仍然将参数放在查询字符串中，尽管这是一个POST请求
        // 如果API设计为接受查询参数，则这是可以的；否则，应考虑将参数放在请求体中
        Response response = RestAssured.given()
               .body(formParams)
                .cookies(cookies)
                .header("Content-Disposition", "multipart/form-data is not yet fully supported")
//                .params(formParams)
                .baseUri("http://10.1.10.141:9031")
                .post(formData); // 假设这里有一个有效的CSRF Token或它是不必要的

        String select_sql = "select * from QCDZ_MC_SL_MCBYJL where  entname like '%浙江非脚后跟建筑设计事务所有限责任公司%'";
        ResultSet resultSet = ConMysql.exec_select(select_sql);
        while (resultSet.next()) {

            // 假设你期望某个字段的值为 'expectedValue'

            String nameid = resultSet.getString("name_id");
            System.out.println("nameid: " + nameid);
        }
        int statusCode = response.getStatusCode();
       String body = response.getBody().asString();

        System.out.println("Status Code: " + statusCode);
//        int chunkSize = 1000; // 每次打印的字符数
//        for (int start = 0; start < body.length(); start += chunkSize) {
//            int end = Math.min(body.length(), start + chunkSize);
//            System.out.println(body.substring(start, end));
//        }

//        if (body != null) {
//            System.out.println("Response Body: " + body);
//        } else {
//            System.out.println("Response Body is null");
//        }

       return statusCode;
    }



//
    }








